/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50737
 Source Host           : 127.0.0.1:3306
 Source Schema         : xxpt

 Target Server Type    : MySQL
 Target Server Version : 50737
 File Encoding         : 65001

 Date: 17/03/2023 19:12:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` bigint(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(200) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `salt` varchar(50) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `rights` varchar(255) DEFAULT NULL,
  `dept_id` bigint(8) DEFAULT NULL COMMENT '部門id',
  `role_id` bigint(8) DEFAULT NULL,
  `last_login` bigint(11) DEFAULT NULL COMMENT '最后登录时间',
  `ip` varchar(50) DEFAULT NULL,
  `sex` smallint(1) DEFAULT '0' COMMENT '0:男，1：女',
  `status` smallint(2) DEFAULT NULL COMMENT '状态 0:可用 1：停用 2：锁定',
  `email` varchar(32) DEFAULT NULL,
  `phone` varchar(32) DEFAULT NULL,
  `add_uid` varchar(50) DEFAULT NULL,
  `add_time` bigint(20) DEFAULT NULL,
  `modify_uid` varchar(50) DEFAULT NULL,
  `modify_time` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`user_id`, `account`, `password`, `salt`, `name`, `rights`, `dept_id`, `role_id`, `last_login`, `ip`, `sex`, `status`, `email`, `phone`, `add_uid`, `add_time`, `modify_uid`, `modify_time`) VALUES (1, 'admin', 'c9de0190c3250ab2710d956325625c711f8d84cfa06ba5707eee1caa3e517fb6', 'ruepwqefdafd', '超管', '', NULL, 1, 1651973218363, '127.0.1.1', 0, 0, 'admin@main.com', '59392240', NULL, NULL, '1', 1541392179971);
INSERT INTO `user` (`user_id`, `account`, `password`, `salt`, `name`, `rights`, `dept_id`, `role_id`, `last_login`, `ip`, `sex`, `status`, `email`, `phone`, `add_uid`, `add_time`, `modify_uid`, `modify_time`) VALUES (2, 'lin', '4c0a3156bbb830182b277d9e23e2782fc663e29a4cb1b6aed9862fd0207beb83', '43214fdasf22', '马山林', NULL, NULL, 2, 1541660869483, '192.168.1.106', 0, 1, '123@163.com', '', '2', NULL, '1', 1542604010915);
INSERT INTO `user` (`user_id`, `account`, `password`, `salt`, `name`, `rights`, `dept_id`, `role_id`, `last_login`, `ip`, `sex`, `status`, `email`, `phone`, `add_uid`, `add_time`, `modify_uid`, `modify_time`) VALUES (3, 'zhangzhiyan1', '4c0a3156bbb830182b277d9e23e2782fc663e29a4cb1b6aed9862fd0207beb83', '43214fdasf22', '张志燕', NULL, NULL, 2, NULL, NULL, 1, 2, '', '', NULL, NULL, '1', 1556013706705);
INSERT INTO `user` (`user_id`, `account`, `password`, `salt`, `name`, `rights`, `dept_id`, `role_id`, `last_login`, `ip`, `sex`, `status`, `email`, `phone`, `add_uid`, `add_time`, `modify_uid`, `modify_time`) VALUES (4, 'bbn_web', NULL, '43214fdasf22', '笨笨鸟科技官网 --', NULL, 2, NULL, NULL, NULL, 0, 1, '123@163.com', '', NULL, NULL, '1', 1547109643488);
INSERT INTO `user` (`user_id`, `account`, `password`, `salt`, `name`, `rights`, `dept_id`, `role_id`, `last_login`, `ip`, `sex`, `status`, `email`, `phone`, `add_uid`, `add_time`, `modify_uid`, `modify_time`) VALUES (5, 'test', 'dc5f8523bdd8780cdb44bd13333ebbe229586a5a2808cb34c5238d40960d56e8', '01il7ilc', '测试-林', NULL, 3, 2, NULL, NULL, 0, 0, '', '', NULL, NULL, '1', 1555641807461);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
